Overview

Brought to you by YData

Dataset statistics

Number of variables	22
Number of observations	1852394
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	310.9 MiB
Average record size in memory	176.0 B

Variable types

DateTime	2
Numeric	9
Text	8
Categorical	3

Alerts

`lat` is highly overall correlated with `merch_lat`	High correlation
`long` is highly overall correlated with `merch_long` and 1 other fields	High correlation
`merch_lat` is highly overall correlated with `lat`	High correlation
`merch_long` is highly overall correlated with `long` and 1 other fields	High correlation
`zip` is highly overall correlated with `long` and 1 other fields	High correlation
`is_fraud` is highly imbalanced (95.3%)	Imbalance
`amt` is highly skewed (γ1 = 40.81280918)	Skewed
`trans_num` has unique values	Unique

Reproduction

Analysis started	2025-04-28 08:25:33.185706
Analysis finished	2025-04-28 08:28:23.420114
Duration	2 minutes and 50.23 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

trans_date_trans_time
Date

Distinct	1819551
Distinct (%)	98.2%
Missing	0
Missing (%)	0.0%
Memory size	14.1 MiB

Minimum	2019-01-01 00:00:18
Maximum	2020-12-31 23:59:34
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

cc_num
Real number (ℝ)

Distinct	999
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.1738604 × 10¹⁷

Minimum	6.0416207 × 10¹⁰
Maximum	4.9923464 × 10¹⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	6.0416207 × 10¹⁰
5-th percentile	6.3048488 × 10¹¹
Q1	1.8004295 × 10¹⁴
median	3.5214173 × 10¹⁵
Q3	4.6422555 × 10¹⁵
95-th percentile	4.497914 × 10¹⁸
Maximum	4.9923464 × 10¹⁸
Range	4.9923463 × 10¹⁸
Interquartile range (IQR)	4.4622125 × 10¹⁵

Descriptive statistics

Standard deviation	1.3091153 × 10¹⁸
Coefficient of variation (CV)	3.1364616
Kurtosis	6.1753558
Mean	4.1738604 × 10¹⁷
Median Absolute Deviation (MAD)	3.0764709 × 10¹⁵
Skewness	2.8510736
Sum	5.0088429 × 10¹⁸
Variance	1.7137828 × 10³⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.02704321 × 10¹³	4392	0.2%
6.538441737 × 10¹⁵	4392	0.2%
4.642255475 × 10¹⁵	4386	0.2%
6.538891243 × 10¹⁵	4386	0.2%
4.364010865 × 10¹⁵	4386	0.2%
6.011438889 × 10¹⁵	4385	0.2%
3.447098678 × 10¹⁴	4385	0.2%
4.512828415 × 10¹⁸	4384	0.2%
4.586810169 × 10¹⁵	4384	0.2%
4.745996322 × 10¹²	4384	0.2%
Other values (989)	1808530	97.6%

Value	Count	Frequency (%)
6.041620718 × 10¹⁰	2196	0.1%
6.042292873 × 10¹⁰	2200	0.1%
6.042309813 × 10¹⁰	738	< 0.1%
6.042785159 × 10¹⁰	743	< 0.1%
6.048700208 × 10¹⁰	735	< 0.1%
6.04905963 × 10¹⁰	1465	0.1%
6.049559311 × 10¹⁰	742	< 0.1%
5.018029536 × 10¹¹	2194	0.1%
5.018181333 × 10¹¹	8	< 0.1%
5.018282048 × 10¹¹	733	< 0.1%

Value	Count	Frequency (%)
4.992346398 × 10¹⁸	2922	0.2%
4.989847571 × 10¹⁸	1471	0.1%
4.980323468 × 10¹⁸	736	< 0.1%
4.973530368 × 10¹⁸	1467	0.1%
4.958589672 × 10¹⁸	2191	0.1%
4.95682899 × 10¹⁸	3657	0.2%
4.911818931 × 10¹⁸	9	< 0.1%
4.906628656 × 10¹⁸	3655	0.2%
4.897067971 × 10¹⁸	1471	0.1%
4.890424427 × 10¹⁸	2189	0.1%

merchant
Text

Distinct	693
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.1 MiB

Length

Max length	43
Median length	36
Mean length	23.130553
Min length	13

Characters and Unicode

Total characters	42846898
Distinct characters	55
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	fraud_Rippin, Kub and Mann
2nd row	fraud_Heller, Gutmann and Zieme
3rd row	fraud_Lind-Buckridge
4th row	fraud_Kutch, Hermiston and Farrell
5th row	fraud_Keeling-Crist

Value	Count	Frequency (%)
and	677362	15.7%
llc	139662	3.2%
inc	131148	3.0%
sons	104651	2.4%
ltd	100896	2.3%
plc	94799	2.2%
group	72089	1.7%
fraud_kutch	15028	0.3%
fraud_schaefer	13367	0.3%
fraud_streich	13235	0.3%
Other values (804)	2956186	68.5%

Most occurring characters

Value	Count	Frequency (%)
a	4158232	9.7%
r	3851348	9.0%
d	3055994	7.1%
e	2665745	6.2%
u	2654462	6.2%
n	2526397	5.9%
	2466029	5.8%
f	1996096	4.7%
_	1852394	4.3%
o	1614017	3.8%
Other values (45)	16006184	37.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	42846898	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	4158232	9.7%
r	3851348	9.0%
d	3055994	7.1%
e	2665745	6.2%
u	2654462	6.2%
n	2526397	5.9%
	2466029	5.8%
f	1996096	4.7%
_	1852394	4.3%
o	1614017	3.8%
Other values (45)	16006184	37.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	42846898	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	4158232	9.7%
r	3851348	9.0%
d	3055994	7.1%
e	2665745	6.2%
u	2654462	6.2%
n	2526397	5.9%
	2466029	5.8%
f	1996096	4.7%
_	1852394	4.3%
o	1614017	3.8%
Other values (45)	16006184	37.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	42846898	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	4158232	9.7%
r	3851348	9.0%
d	3055994	7.1%
e	2665745	6.2%
u	2654462	6.2%
n	2526397	5.9%
	2466029	5.8%
f	1996096	4.7%
_	1852394	4.3%
o	1614017	3.8%
Other values (45)	16006184	37.4%

category
Categorical

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.1 MiB

gas_transport	188029
grocery_pos	176191
home	175460
shopping_pos	166463
kids_pets	161727
Other values (9)	984524

Length

Max length	14
Median length	12
Mean length	10.525913
Min length	4

Characters and Unicode

Total characters	19498139
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	misc_net
2nd row	grocery_pos
3rd row	entertainment
4th row	gas_transport
5th row	misc_pos

Common Values

Value	Count	Frequency (%)
gas_transport	188029	10.2%
grocery_pos	176191	9.5%
home	175460	9.5%
shopping_pos	166463	9.0%
kids_pets	161727	8.7%
shopping_net	139322	7.5%
entertainment	134118	7.2%
food_dining	130729	7.1%
personal_care	130085	7.0%
health_fitness	122553	6.6%
Other values (4)	327717	17.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
gas_transport	188029	10.2%
grocery_pos	176191	9.5%
home	175460	9.5%
shopping_pos	166463	9.0%
kids_pets	161727	8.7%
shopping_net	139322	7.5%
entertainment	134118	7.2%
food_dining	130729	7.1%
personal_care	130085	7.0%
health_fitness	122553	6.6%
Other values (4)	327717	17.7%

Most occurring characters

Value	Count	Frequency (%)
s	2042254	10.5%
e	1838696	9.4%
o	1758769	9.0%
n	1705118	8.7%
p	1548294	7.9%
t	1538055	7.9%
_	1484860	7.6%
r	1310440	6.7%
i	1190524	6.1%
a	950855	4.9%
Other values (10)	4130274	21.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	19498139	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	2042254	10.5%
e	1838696	9.4%
o	1758769	9.0%
n	1705118	8.7%
p	1548294	7.9%
t	1538055	7.9%
_	1484860	7.6%
r	1310440	6.7%
i	1190524	6.1%
a	950855	4.9%
Other values (10)	4130274	21.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	19498139	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	2042254	10.5%
e	1838696	9.4%
o	1758769	9.0%
n	1705118	8.7%
p	1548294	7.9%
t	1538055	7.9%
_	1484860	7.6%
r	1310440	6.7%
i	1190524	6.1%
a	950855	4.9%
Other values (10)	4130274	21.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	19498139	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	2042254	10.5%
e	1838696	9.4%
o	1758769	9.0%
n	1705118	8.7%
p	1548294	7.9%
t	1538055	7.9%
_	1484860	7.6%
r	1310440	6.7%
i	1190524	6.1%
a	950855	4.9%
Other values (10)	4130274	21.2%

amt
Real number (ℝ)

Skewed

Distinct	60616
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	70.063567

Minimum	1
Maximum	28948.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	1
5-th percentile	2.44
Q1	9.64
median	47.45
Q3	83.1
95-th percentile	195.34
Maximum	28948.9
Range	28947.9
Interquartile range (IQR)	73.46

Descriptive statistics

Standard deviation	159.25397
Coefficient of variation (CV)	2.2729927
Kurtosis	4181.9073
Mean	70.063567
Median Absolute Deviation (MAD)	37.46
Skewness	40.812809
Sum	1.2978533 × 10⁸
Variance	25361.828
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.14	779	< 0.1%
1.1	745	< 0.1%
1.04	744	< 0.1%
1.08	741	< 0.1%
1.25	737	< 0.1%
1.2	737	< 0.1%
1.02	736	< 0.1%
1.01	735	< 0.1%
1.22	727	< 0.1%
1.03	726	< 0.1%
Other values (60606)	1844987	99.6%

Value	Count	Frequency (%)
1	332	< 0.1%
1.01	735	< 0.1%
1.02	736	< 0.1%
1.03	726	< 0.1%
1.04	744	< 0.1%
1.05	721	< 0.1%
1.06	671	< 0.1%
1.07	723	< 0.1%
1.08	741	< 0.1%
1.09	720	< 0.1%

Value	Count	Frequency (%)
28948.9	1	< 0.1%
27390.12	1	< 0.1%
27119.77	1	< 0.1%
26544.12	1	< 0.1%
25086.94	1	< 0.1%
22768.11	1	< 0.1%
21437.71	1	< 0.1%
19364.91	1	< 0.1%
17897.24	1	< 0.1%
16837.08	1	< 0.1%

first
Text

Distinct	355
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.1 MiB

Length

Max length	11
Median length	9
Mean length	6.0802977
Min length	3

Characters and Unicode

Total characters	11263107
Distinct characters	49
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Jennifer
2nd row	Stephanie
3rd row	Edward
4th row	Jeremy
5th row	Tyler

Value	Count	Frequency (%)
christopher	38112	2.1%
robert	30743	1.7%
jessica	29236	1.6%
david	28564	1.5%
michael	28539	1.5%
james	28496	1.5%
jennifer	24181	1.3%
john	23445	1.3%
mary	23424	1.3%
william	23396	1.3%
Other values (345)	1574258	85.0%

Most occurring characters

Value	Count	Frequency (%)
a	1438618	12.8%
e	1230164	10.9%
i	883628	7.8%
n	877668	7.8%
r	867952	7.7%
l	554750	4.9%
h	493347	4.4%
s	463151	4.1%
t	444904	4.0%
o	384330	3.4%
Other values (39)	3624595	32.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	11263107	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	1438618	12.8%
e	1230164	10.9%
i	883628	7.8%
n	877668	7.8%
r	867952	7.7%
l	554750	4.9%
h	493347	4.4%
s	463151	4.1%
t	444904	4.0%
o	384330	3.4%
Other values (39)	3624595	32.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	11263107	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	1438618	12.8%
e	1230164	10.9%
i	883628	7.8%
n	877668	7.8%
r	867952	7.7%
l	554750	4.9%
h	493347	4.4%
s	463151	4.1%
t	444904	4.0%
o	384330	3.4%
Other values (39)	3624595	32.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	11263107	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	1438618	12.8%
e	1230164	10.9%
i	883628	7.8%
n	877668	7.8%
r	867952	7.7%
l	554750	4.9%
h	493347	4.4%
s	463151	4.1%
t	444904	4.0%
o	384330	3.4%
Other values (39)	3624595	32.2%

last
Text

Distinct	486
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.1 MiB

Length

Max length	11
Median length	10
Mean length	6.1123751
Min length	2

Characters and Unicode

Total characters	11322527
Distinct characters	48
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Banks
2nd row	Gill
3rd row	Sanchez
4th row	White
5th row	Garcia

Value	Count	Frequency (%)
smith	40940	2.2%
williams	33661	1.8%
davis	31434	1.7%
johnson	28590	1.5%
rodriguez	24879	1.3%
martinez	21246	1.1%
jones	19825	1.1%
lewis	18293	1.0%
miller	16821	0.9%
gonzalez	16809	0.9%
Other values (476)	1599896	86.4%

Most occurring characters

Value	Count	Frequency (%)
e	1122673	9.9%
r	941641	8.3%
a	926704	8.2%
n	869662	7.7%
o	832319	7.4%
l	698286	6.2%
s	696904	6.2%
i	622878	5.5%
t	412730	3.6%
h	327959	2.9%
Other values (38)	3870771	34.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	11322527	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1122673	9.9%
r	941641	8.3%
a	926704	8.2%
n	869662	7.7%
o	832319	7.4%
l	698286	6.2%
s	696904	6.2%
i	622878	5.5%
t	412730	3.6%
h	327959	2.9%
Other values (38)	3870771	34.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	11322527	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1122673	9.9%
r	941641	8.3%
a	926704	8.2%
n	869662	7.7%
o	832319	7.4%
l	698286	6.2%
s	696904	6.2%
i	622878	5.5%
t	412730	3.6%
h	327959	2.9%
Other values (38)	3870771	34.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	11322527	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1122673	9.9%
r	941641	8.3%
a	926704	8.2%
n	869662	7.7%
o	832319	7.4%
l	698286	6.2%
s	696904	6.2%
i	622878	5.5%
t	412730	3.6%
h	327959	2.9%
Other values (38)	3870771	34.2%

gender
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.1 MiB

F	1014749
M	837645

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1852394
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	F
2nd row	F
3rd row	M
4th row	M
5th row	M

Common Values

Value	Count	Frequency (%)
F	1014749	54.8%
M	837645	45.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
f	1014749	54.8%
m	837645	45.2%

Most occurring characters

Value	Count	Frequency (%)
F	1014749	54.8%
M	837645	45.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1852394	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
F	1014749	54.8%
M	837645	45.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1852394	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
F	1014749	54.8%
M	837645	45.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1852394	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
F	1014749	54.8%
M	837645	45.2%

street
Text

Distinct	999
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.1 MiB

Length

Max length	35
Median length	29
Mean length	22.231289
Min length	12

Characters and Unicode

Total characters	41181107
Distinct characters	62
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	561 Perry Cove
2nd row	43039 Riley Greens Suite 393
3rd row	594 White Dale Suite 530
4th row	9443 Cynthia Court Apt. 038
5th row	408 Bradley Rest

Value	Count	Frequency (%)
apt	468297	6.4%
suite	437016	5.9%
island	32903	0.4%
michael	27058	0.4%
islands	25611	0.3%
station	25602	0.3%
common	25585	0.3%
david	24853	0.3%
brooks	24143	0.3%
fields	23400	0.3%
Other values (1959)	6253340	84.9%

Most occurring characters

Value	Count	Frequency (%)
	5515414	13.4%
e	2561201	6.2%
a	2077034	5.0%
i	1851621	4.5%
t	1782137	4.3%
r	1576757	3.8%
n	1523518	3.7%
s	1476954	3.6%
l	1270600	3.1%
o	1251043	3.0%
Other values (52)	20294828	49.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	41181107	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	5515414	13.4%
e	2561201	6.2%
a	2077034	5.0%
i	1851621	4.5%
t	1782137	4.3%
r	1576757	3.8%
n	1523518	3.7%
s	1476954	3.6%
l	1270600	3.1%
o	1251043	3.0%
Other values (52)	20294828	49.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	41181107	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	5515414	13.4%
e	2561201	6.2%
a	2077034	5.0%
i	1851621	4.5%
t	1782137	4.3%
r	1576757	3.8%
n	1523518	3.7%
s	1476954	3.6%
l	1270600	3.1%
o	1251043	3.0%
Other values (52)	20294828	49.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	41181107	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	5515414	13.4%
e	2561201	6.2%
a	2077034	5.0%
i	1851621	4.5%
t	1782137	4.3%
r	1576757	3.8%
n	1523518	3.7%
s	1476954	3.6%
l	1270600	3.1%
o	1251043	3.0%
Other values (52)	20294828	49.3%

city
Text

Distinct	906
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.1 MiB

Length

Max length	25
Median length	21
Mean length	8.6526209
Min length	3

Characters and Unicode

Total characters	16028063
Distinct characters	52
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Moravian Falls
2nd row	Orient
3rd row	Malad City
4th row	Boulder
5th row	Doe Hill

Value	Count	Frequency (%)
city	30780	1.3%
west	27847	1.2%
saint	20483	0.9%
north	20472	0.9%
falls	18286	0.8%
new	16857	0.7%
mount	16098	0.7%
lake	16089	0.7%
san	14638	0.6%
springs	12414	0.5%
Other values (929)	2118136	91.6%

Most occurring characters

Value	Count	Frequency (%)
e	1555978	9.7%
a	1334959	8.3%
n	1173952	7.3%
o	1168590	7.3%
l	1115539	7.0%
r	1070587	6.7%
i	1007053	6.3%
t	855511	5.3%
s	637587	4.0%
	459706	2.9%
Other values (42)	5648601	35.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	16028063	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1555978	9.7%
a	1334959	8.3%
n	1173952	7.3%
o	1168590	7.3%
l	1115539	7.0%
r	1070587	6.7%
i	1007053	6.3%
t	855511	5.3%
s	637587	4.0%
	459706	2.9%
Other values (42)	5648601	35.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	16028063	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1555978	9.7%
a	1334959	8.3%
n	1173952	7.3%
o	1168590	7.3%
l	1115539	7.0%
r	1070587	6.7%
i	1007053	6.3%
t	855511	5.3%
s	637587	4.0%
	459706	2.9%
Other values (42)	5648601	35.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	16028063	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1555978	9.7%
a	1334959	8.3%
n	1173952	7.3%
o	1168590	7.3%
l	1115539	7.0%
r	1070587	6.7%
i	1007053	6.3%
t	855511	5.3%
s	637587	4.0%
	459706	2.9%
Other values (42)	5648601	35.2%

state
Text

Distinct	51
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.1 MiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	3704788
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NC
2nd row	WA
3rd row	ID
4th row	MT
5th row	VA

Value	Count	Frequency (%)
tx	135269	7.3%
ny	119419	6.4%
pa	114173	6.2%
ca	80495	4.3%
oh	66627	3.6%
mi	65825	3.6%
il	62212	3.4%
fl	60775	3.3%
al	58521	3.2%
mo	54904	3.0%
Other values (41)	1034174	55.8%

Most occurring characters

Value	Count	Frequency (%)
A	508580	13.7%
N	406389	11.0%
M	314756	8.5%
I	260547	7.0%
T	220136	5.9%
L	211461	5.7%
O	205755	5.6%
C	201235	5.4%
Y	188176	5.1%
X	135269	3.7%
Other values (14)	1052484	28.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3704788	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	508580	13.7%
N	406389	11.0%
M	314756	8.5%
I	260547	7.0%
T	220136	5.9%
L	211461	5.7%
O	205755	5.6%
C	201235	5.4%
Y	188176	5.1%
X	135269	3.7%
Other values (14)	1052484	28.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3704788	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	508580	13.7%
N	406389	11.0%
M	314756	8.5%
I	260547	7.0%
T	220136	5.9%
L	211461	5.7%
O	205755	5.6%
C	201235	5.4%
Y	188176	5.1%
X	135269	3.7%
Other values (14)	1052484	28.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3704788	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	508580	13.7%
N	406389	11.0%
M	314756	8.5%
I	260547	7.0%
T	220136	5.9%
L	211461	5.7%
O	205755	5.6%
C	201235	5.4%
Y	188176	5.1%
X	135269	3.7%
Other values (14)	1052484	28.4%

zip
Real number (ℝ)

High correlation

Distinct	985
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48813.258

Minimum	1257
Maximum	99921
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	1257
5-th percentile	7208
Q1	26237
median	48174
Q3	72042
95-th percentile	94569
Maximum	99921
Range	98664
Interquartile range (IQR)	45805

Descriptive statistics

Standard deviation	26881.846
Coefficient of variation (CV)	0.55070788
Kurtosis	-1.0960542
Mean	48813.258
Median Absolute Deviation (MAD)	23068
Skewness	0.078949647
Sum	9.0421387 × 10¹⁰
Variance	7.2263364 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
82514	5116	0.3%
73754	5116	0.3%
48088	5115	0.3%
34112	5108	0.3%
61454	4392	0.2%
16114	4392	0.2%
84540	4386	0.2%
89512	4386	0.2%
72476	4386	0.2%
33872	4385	0.2%
Other values (975)	1805612	97.5%

Value	Count	Frequency (%)
1257	2923	0.2%
1330	1466	0.1%
1535	734	< 0.1%
1545	1468	0.1%
1612	738	< 0.1%
1843	3652	0.2%
1844	2919	0.2%
2180	738	< 0.1%
2630	2924	0.2%
2908	745	< 0.1%

Value	Count	Frequency (%)
99921	14	< 0.1%
99783	2203	0.1%
99747	12	< 0.1%
99746	734	< 0.1%
99323	3651	0.2%
99160	4362	0.2%
99116	15	< 0.1%
99113	1463	0.1%
99033	3646	0.2%
98836	740	< 0.1%

lat
Real number (ℝ)

High correlation

Distinct	983
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.539311

Minimum	20.0271
Maximum	66.6933
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	20.0271
5-th percentile	29.8826
Q1	34.6689
median	39.3543
Q3	41.9404
95-th percentile	45.8433
Maximum	66.6933
Range	46.6662
Interquartile range (IQR)	7.2715

Descriptive statistics

Standard deviation	5.0714704
Coefficient of variation (CV)	0.13159214
Kurtosis	0.79107707
Mean	38.539311
Median Absolute Deviation (MAD)	3.3597
Skewness	-0.19199899
Sum	71389988
Variance	25.719812
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
43.0048	5116	0.3%
36.385	5116	0.3%
42.5164	5115	0.3%
26.1184	5108	0.3%
41.3851	4392	0.2%
40.6761	4392	0.2%
36.0244	4386	0.2%
38.9999	4386	0.2%
39.5483	4386	0.2%
34.2853	4385	0.2%
Other values (973)	1805612	97.5%

Value	Count	Frequency (%)
20.0271	2186	0.1%
20.0827	1463	0.1%
24.6557	3655	0.2%
26.1184	5108	0.3%
26.3304	741	< 0.1%
26.3771	732	< 0.1%
26.4215	4362	0.2%
26.4722	3650	0.2%
26.529	2202	0.1%
26.6939	1467	0.1%

Value	Count	Frequency (%)
66.6933	12	< 0.1%
65.6899	734	< 0.1%
64.7556	2203	0.1%
55.4732	14	< 0.1%
48.8878	4362	0.2%
48.8856	2909	0.2%
48.8328	2200	0.1%
48.6669	1469	0.1%
48.6031	4376	0.2%
48.4786	2916	0.2%

long
Real number (ℝ)

High correlation

Distinct	983
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-90.227832

Minimum	-165.6723
Maximum	-67.9503
Zeros	0
Zeros (%)	0.0%
Negative	1852394
Negative (%)	100.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	-165.6723
5-th percentile	-119.0825
Q1	-96.798
median	-87.4769
Q3	-80.158
95-th percentile	-73.5365
Maximum	-67.9503
Range	97.722
Interquartile range (IQR)	16.64

Descriptive statistics

Standard deviation	13.747895
Coefficient of variation (CV)	-0.15236867
Kurtosis	1.8375586
Mean	-90.227832
Median Absolute Deviation (MAD)	8.1527
Skewness	-1.1469188
Sum	-1.671375 × 10⁸
Variance	189.00461
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-108.8964	5116	0.3%
-98.0727	5116	0.3%
-82.9832	5115	0.3%
-81.7361	5108	0.3%
-91.0391	4392	0.2%
-80.1752	4392	0.2%
-82.7243	4391	0.2%
-119.7957	4386	0.2%
-109.615	4386	0.2%
-90.9288	4386	0.2%
Other values (973)	1805606	97.5%

Value	Count	Frequency (%)
-165.6723	2203	0.1%
-156.292	734	< 0.1%
-155.488	1463	0.1%
-155.3697	2186	0.1%
-153.994	12	< 0.1%
-133.1171	14	< 0.1%
-124.4409	1467	0.1%
-124.2174	2195	0.1%
-124.1587	1465	0.1%
-124.1437	2198	0.1%

Value	Count	Frequency (%)
-67.9503	2922	0.2%
-68.5565	1467	0.1%
-69.2675	743	< 0.1%
-69.4828	2931	0.2%
-69.9576	737	< 0.1%
-69.9656	4374	0.2%
-70.1031	9	< 0.1%
-70.239	1455	0.1%
-70.3001	2924	0.2%
-70.3457	2196	0.1%

city_pop
Real number (ℝ)

Distinct	891
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	88643.675

Minimum	23
Maximum	2906700
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	23
5-th percentile	139
Q1	741
median	2443
Q3	20328
95-th percentile	525713
Maximum	2906700
Range	2906677
Interquartile range (IQR)	19587

Descriptive statistics

Standard deviation	301487.62
Coefficient of variation (CV)	3.4011182
Kurtosis	37.572846
Mean	88643.675
Median Absolute Deviation (MAD)	2188
Skewness	5.5908046
Sum	1.6420301 × 10¹¹
Variance	9.0894784 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
606	8049	0.4%
1595797	7312	0.4%
1312922	7297	0.4%
241	6578	0.4%
1766	6556	0.4%
2906700	5865	0.3%
302	5853	0.3%
198	5850	0.3%
276002	5849	0.3%
1126	5841	0.3%
Other values (881)	1787344	96.5%

Value	Count	Frequency (%)
23	2915	0.2%
37	1469	0.1%
43	2920	0.2%
46	4386	0.2%
47	734	< 0.1%
49	1472	0.1%
51	1470	0.1%
52	740	< 0.1%
53	3660	0.2%
60	1472	0.1%

Value	Count	Frequency (%)
2906700	5865	0.3%
2504700	2929	0.2%
2383912	737	< 0.1%
1595797	7312	0.4%
1577385	3680	0.2%
1526206	5113	0.3%
1417793	8	< 0.1%
1382480	2913	0.2%
1312922	7297	0.4%
1263321	5141	0.3%

job
Text

Distinct	497
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.1 MiB

Length

Max length	59
Median length	38
Mean length	20.232398
Min length	3

Characters and Unicode

Total characters	37478372
Distinct characters	53
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Psychologist, counselling
2nd row	Special educational needs teacher
3rd row	Nature conservation officer
4th row	Patent attorney
5th row	Dance movement psychotherapist

Value	Count	Frequency (%)
engineer	188048	4.6%
officer	158202	3.8%
manager	87837	2.1%
scientist	79740	1.9%
designer	74639	1.8%
surveyor	70288	1.7%
teacher	54865	1.3%
psychologist	46856	1.1%
research	42426	1.0%
editor	40958	1.0%
Other values (457)	3270295	79.5%

Most occurring characters

Value	Count	Frequency (%)
e	4003951	10.7%
i	3407729	9.1%
r	3140909	8.4%
a	2593110	6.9%
t	2547852	6.8%
n	2521475	6.7%
	2261760	6.0%
o	2133314	5.7%
s	2064644	5.5%
c	1890653	5.0%
Other values (43)	10912975	29.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	37478372	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	4003951	10.7%
i	3407729	9.1%
r	3140909	8.4%
a	2593110	6.9%
t	2547852	6.8%
n	2521475	6.7%
	2261760	6.0%
o	2133314	5.7%
s	2064644	5.5%
c	1890653	5.0%
Other values (43)	10912975	29.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	37478372	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	4003951	10.7%
i	3407729	9.1%
r	3140909	8.4%
a	2593110	6.9%
t	2547852	6.8%
n	2521475	6.7%
	2261760	6.0%
o	2133314	5.7%
s	2064644	5.5%
c	1890653	5.0%
Other values (43)	10912975	29.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	37478372	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	4003951	10.7%
i	3407729	9.1%
r	3140909	8.4%
a	2593110	6.9%
t	2547852	6.8%
n	2521475	6.7%
	2261760	6.0%
o	2133314	5.7%
s	2064644	5.5%
c	1890653	5.0%
Other values (43)	10912975	29.1%

dob
Date

Distinct	984
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.1 MiB

Minimum	1924-10-30 00:00:00
Maximum	2005-01-29 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

trans_num
Text

Unique

Distinct	1852394
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	14.1 MiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	59276608
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1852394 ?
Unique (%)	100.0%

Sample

1st row	0b242abb623afc578575680df30655b9
2nd row	1f76529f8574734946361c461b024d99
3rd row	a1a22d70485983eac12b5b88dad1cf95
4th row	6b849c168bdad6f867558c3793159a81
5th row	a41d7549acf90789359a9aa5346dcb46

Value	Count	Frequency (%)
d71c95ab6b7356dd74389d41df429c87	1	< 0.1%
1765bb45b3aa3224b4cdcb6e7a96cee3	1	< 0.1%
0b242abb623afc578575680df30655b9	1	< 0.1%
1f76529f8574734946361c461b024d99	1	< 0.1%
a1a22d70485983eac12b5b88dad1cf95	1	< 0.1%
6b849c168bdad6f867558c3793159a81	1	< 0.1%
a41d7549acf90789359a9aa5346dcb46	1	< 0.1%
189a841a0a8ba03058526bcfe566aab5	1	< 0.1%
83ec1cc84142af6e2acf10c44949e720	1	< 0.1%
6d294ed2cc447d2c71c7171a3d54967c	1	< 0.1%
Other values (1852384)	1852384	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
9	3708557	6.3%
4	3707696	6.3%
7	3707599	6.3%
2	3707045	6.3%
3	3706132	6.3%
1	3705118	6.3%
d	3704966	6.3%
a	3704452	6.2%
8	3704258	6.2%
c	3703707	6.2%
Other values (6)	22217078	37.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	59276608	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
9	3708557	6.3%
4	3707696	6.3%
7	3707599	6.3%
2	3707045	6.3%
3	3706132	6.3%
1	3705118	6.3%
d	3704966	6.3%
a	3704452	6.2%
8	3704258	6.2%
c	3703707	6.2%
Other values (6)	22217078	37.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	59276608	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
9	3708557	6.3%
4	3707696	6.3%
7	3707599	6.3%
2	3707045	6.3%
3	3706132	6.3%
1	3705118	6.3%
d	3704966	6.3%
a	3704452	6.2%
8	3704258	6.2%
c	3703707	6.2%
Other values (6)	22217078	37.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	59276608	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
9	3708557	6.3%
4	3707696	6.3%
7	3707599	6.3%
2	3707045	6.3%
3	3706132	6.3%
1	3705118	6.3%
d	3704966	6.3%
a	3704452	6.2%
8	3704258	6.2%
c	3703707	6.2%
Other values (6)	22217078	37.5%

unix_time
Real number (ℝ)

Distinct	1819583
Distinct (%)	98.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.3586742 × 10⁹

Minimum	1.325376 × 10⁹
Maximum	1.3885344 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	1.325376 × 10⁹
5-th percentile	1.3300982 × 10⁹
Q1	1.3430168 × 10⁹
median	1.3570893 × 10⁹
Q3	1.3745815 × 10⁹
95-th percentile	1.3867821 × 10⁹
Maximum	1.3885344 × 10⁹
Range	63158356
Interquartile range (IQR)	31564662

Descriptive statistics

Standard deviation	18195081
Coefficient of variation (CV)	0.013391791
Kurtosis	-1.1995793
Mean	1.3586742 × 10⁹
Median Absolute Deviation (MAD)	15789076
Skewness	-0.019735681
Sum	2.5168 × 10¹⁵
Variance	3.3106099 × 10¹⁴
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1381001869	4	< 0.1%
1370177227	4	< 0.1%
1370050667	4	< 0.1%
1386957227	4	< 0.1%
1335110521	4	< 0.1%
1387468942	4	< 0.1%
1387312599	4	< 0.1%
1385924621	3	< 0.1%
1372438073	3	< 0.1%
1354282266	3	< 0.1%
Other values (1819573)	1852357	> 99.9%

Value	Count	Frequency (%)
1325376018	1	< 0.1%
1325376044	1	< 0.1%
1325376051	1	< 0.1%
1325376076	1	< 0.1%
1325376186	1	< 0.1%
1325376248	1	< 0.1%
1325376282	1	< 0.1%
1325376308	1	< 0.1%
1325376318	1	< 0.1%
1325376361	1	< 0.1%

Value	Count	Frequency (%)
1388534374	1	< 0.1%
1388534364	1	< 0.1%
1388534355	1	< 0.1%
1388534349	1	< 0.1%
1388534347	1	< 0.1%
1388534314	1	< 0.1%
1388534284	1	< 0.1%
1388534276	1	< 0.1%
1388534270	1	< 0.1%
1388534238	1	< 0.1%

merch_lat
Real number (ℝ)

High correlation

Distinct	1754157
Distinct (%)	94.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.538976

Minimum	19.027422
Maximum	67.510267
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	19.027422
5-th percentile	29.753795
Q1	34.740122
median	39.3689
Q3	41.956263
95-th percentile	46.002013
Maximum	67.510267
Range	48.482845
Interquartile range (IQR)	7.2161407

Descriptive statistics

Standard deviation	5.1056039
Coefficient of variation (CV)	0.13247897
Kurtosis	0.77423362
Mean	38.538976
Median Absolute Deviation (MAD)	3.38992
Skewness	-0.1880969
Sum	71389368
Variance	26.067191
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.16396	4	< 0.1%
38.714096	4	< 0.1%
42.889354	4	< 0.1%
38.206985	4	< 0.1%
37.669788	4	< 0.1%
41.785897	4	< 0.1%
41.301611	4	< 0.1%
41.23339	4	< 0.1%
43.747922	4	< 0.1%
38.164527	4	< 0.1%
Other values (1754147)	1852354	> 99.9%

Value	Count	Frequency (%)
19.027422	1	< 0.1%
19.027785	1	< 0.1%
19.027804	1	< 0.1%
19.027849	1	< 0.1%
19.029798	1	< 0.1%
19.031242	1	< 0.1%
19.032277	1	< 0.1%
19.032689	1	< 0.1%
19.033288	1	< 0.1%
19.034282	1	< 0.1%

Value	Count	Frequency (%)
67.510267	1	< 0.1%
67.441518	1	< 0.1%
67.397018	1	< 0.1%
67.188111	1	< 0.1%
67.064277	1	< 0.1%
66.835174	1	< 0.1%
66.682905	1	< 0.1%
66.679297	1	< 0.1%
66.674714	1	< 0.1%
66.67355	1	< 0.1%

merch_long
Real number (ℝ)

High correlation

Distinct	1809753
Distinct (%)	97.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-90.22794

Minimum	-166.67157
Maximum	-66.950902
Zeros	0
Zeros (%)	0.0%
Negative	1852394
Negative (%)	100.0%
Memory size	14.1 MiB

Quantile statistics

Minimum	-166.67157
5-th percentile	-119.30928
Q1	-96.89944
median	-87.440694
Q3	-80.245108
95-th percentile	-73.365169
Maximum	-66.950902
Range	99.720673
Interquartile range (IQR)	16.654332

Descriptive statistics

Standard deviation	13.759692
Coefficient of variation (CV)	-0.15249924
Kurtosis	1.8312584
Mean	-90.22794
Median Absolute Deviation (MAD)	8.2235005
Skewness	-1.143933
Sum	-1.6713769 × 10⁸
Variance	189.32913
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-87.830842	4	< 0.1%
-96.511763	4	< 0.1%
-80.940524	4	< 0.1%
-81.219189	4	< 0.1%
-90.85685	4	< 0.1%
-74.618269	4	< 0.1%
-87.116414	4	< 0.1%
-81.036745	4	< 0.1%
-81.995265	4	< 0.1%
-74.433003	4	< 0.1%
Other values (1809743)	1852354	> 99.9%

Value	Count	Frequency (%)
-166.671575	1	< 0.1%
-166.671242	1	< 0.1%
-166.670685	1	< 0.1%
-166.670132	1	< 0.1%
-166.670006	1	< 0.1%
-166.66991	1	< 0.1%
-166.669812	1	< 0.1%
-166.669638	1	< 0.1%
-166.666179	1	< 0.1%
-166.664828	1	< 0.1%

Value	Count	Frequency (%)
-66.950902	1	< 0.1%
-66.952026	1	< 0.1%
-66.952352	1	< 0.1%
-66.955602	1	< 0.1%
-66.955996	1	< 0.1%
-66.95654	1	< 0.1%
-66.957364	1	< 0.1%
-66.958659	1	< 0.1%
-66.958751	1	< 0.1%
-66.959178	1	< 0.1%

is_fraud
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.1 MiB

0	1842743
1	9651

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1852394
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	1842743	99.5%
1	9651	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	1842743	99.5%
1	9651	0.5%

Most occurring characters

Value	Count	Frequency (%)
0	1842743	99.5%
1	9651	0.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1852394	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	1842743	99.5%
1	9651	0.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1852394	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	1842743	99.5%
1	9651	0.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1852394	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	1842743	99.5%
1	9651	0.5%

Interactions

Correlations

	amt	category	cc_num	city_pop	gender	is_fraud	lat	long	merch_lat	merch_long	unix_time	zip
amt	1.000	0.019	-0.001	-0.024	0.001	0.000	0.013	-0.000	0.013	-0.000	-0.001	0.001
category	0.019	1.000	0.008	0.014	0.054	0.067	0.010	0.009	0.011	0.009	0.001	0.011
cc_num	-0.001	0.008	1.000	0.049	0.052	0.003	-0.003	-0.013	-0.003	-0.013	0.001	0.013
city_pop	-0.024	0.014	0.049	1.000	0.090	0.002	-0.264	0.087	-0.263	0.086	-0.003	-0.040
gender	0.001	0.054	0.052	0.090	1.000	0.006	0.101	0.091	0.103	0.083	0.000	0.116
is_fraud	0.000	0.067	0.003	0.002	0.006	1.000	0.038	0.038	0.038	0.038	0.022	0.004
lat	0.013	0.010	-0.003	-0.264	0.101	0.038	1.000	0.105	0.991	0.104	0.001	-0.162
long	-0.000	0.009	-0.013	0.087	0.091	0.038	0.105	1.000	0.105	0.998	-0.001	-0.959
merch_lat	0.013	0.011	-0.003	-0.263	0.103	0.038	0.991	0.105	1.000	0.104	0.001	-0.162
merch_long	-0.000	0.009	-0.013	0.086	0.083	0.038	0.104	0.998	0.104	1.000	-0.001	-0.957
unix_time	-0.001	0.001	0.001	-0.003	0.000	0.022	0.001	-0.001	0.001	-0.001	1.000	0.001
zip	0.001	0.011	0.013	-0.040	0.116	0.004	-0.162	-0.959	-0.162	-0.957	0.001	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	trans_date_trans_time	cc_num	merchant	category	amt	first	last	gender	street	city	state	zip	lat	long	city_pop	job	dob	trans_num	unix_time	merch_lat	merch_long
0	2019-01-01 00:00:18	2703186189652095	fraud_Rippin, Kub and Mann	misc_net	4.97	Jennifer	Banks	F	561 Perry Cove	Moravian Falls	NC	28654	36.0788	-81.1781	3495	Psychologist, counselling	1988-03-09	0b242abb623afc578575680df30655b9	1325376018	36.011293	-82.048315
1	2019-01-01 00:00:44	630423337322	fraud_Heller, Gutmann and Zieme	grocery_pos	107.23	Stephanie	Gill	F	43039 Riley Greens Suite 393	Orient	WA	99160	48.8878	-118.2105	149	Special educational needs teacher	1978-06-21	1f76529f8574734946361c461b024d99	1325376044	49.159047	-118.186462
2	2019-01-01 00:00:51	38859492057661	fraud_Lind-Buckridge	entertainment	220.11	Edward	Sanchez	M	594 White Dale Suite 530	Malad City	ID	83252	42.1808	-112.2620	4154	Nature conservation officer	1962-01-19	a1a22d70485983eac12b5b88dad1cf95	1325376051	43.150704	-112.154481
3	2019-01-01 00:01:16	3534093764340240	fraud_Kutch, Hermiston and Farrell	gas_transport	45.00	Jeremy	White	M	9443 Cynthia Court Apt. 038	Boulder	MT	59632	46.2306	-112.1138	1939	Patent attorney	1967-01-12	6b849c168bdad6f867558c3793159a81	1325376076	47.034331	-112.561071
4	2019-01-01 00:03:06	375534208663984	fraud_Keeling-Crist	misc_pos	41.96	Tyler	Garcia	M	408 Bradley Rest	Doe Hill	VA	24433	38.4207	-79.4629	99	Dance movement psychotherapist	1986-03-28	a41d7549acf90789359a9aa5346dcb46	1325376186	38.674999	-78.632459
5	2019-01-01 00:04:08	4767265376804500	fraud_Stroman, Hudson and Erdman	gas_transport	94.63	Jennifer	Conner	F	4655 David Island	Dublin	PA	18917	40.3750	-75.2045	2158	Transport planner	1961-06-19	189a841a0a8ba03058526bcfe566aab5	1325376248	40.653382	-76.152667
6	2019-01-01 00:04:42	30074693890476	fraud_Rowe-Vandervort	grocery_net	44.54	Kelsey	Richards	F	889 Sarah Station Suite 624	Holcomb	KS	67851	37.9931	-100.9893	2691	Arboriculturist	1993-08-16	83ec1cc84142af6e2acf10c44949e720	1325376282	37.162705	-100.153370
7	2019-01-01 00:05:08	6011360759745864	fraud_Corwin-Collins	gas_transport	71.65	Steven	Williams	M	231 Flores Pass Suite 720	Edinburg	VA	22824	38.8432	-78.6003	6018	Designer, multimedia	1947-08-21	6d294ed2cc447d2c71c7171a3d54967c	1325376308	38.948089	-78.540296
8	2019-01-01 00:05:18	4922710831011201	fraud_Herzog Ltd	misc_pos	4.27	Heather	Chase	F	6888 Hicks Stream Suite 954	Manor	PA	15665	40.3359	-79.6607	1472	Public affairs consultant	1941-03-07	fc28024ce480f8ef21a32d64c93a29f5	1325376318	40.351813	-79.958146
9	2019-01-01 00:06:01	2720830304681674	fraud_Schoen, Kuphal and Nitzsche	grocery_pos	198.39	Melissa	Aguilar	F	21326 Taylor Squares Suite 708	Clarksville	TN	37040	36.5220	-87.3490	151785	Pathologist	1974-03-28	3b9014ea8fb80bd65de0b1463b00b00e	1325376361	37.179198	-87.485381

	trans_date_trans_time	cc_num	merchant	category	amt	first	last	gender	street	city	state	zip	lat	long	city_pop	job	dob	trans_num	unix_time	merch_lat	merch_long
1852384	2020-12-31 23:57:18	30344654314976	fraud_Larkin, Stracke and Greenfelder	entertainment	46.71	Christine	Johnson	F	8011 Chapman Tunnel Apt. 568	Blairsden-Graeagle	CA	96103	39.8127	-120.6405	1725	Chartered legal executive (England and Wales)	1967-05-27	a7105564935ea3977dc61ff9ced3bf5e	1388534238	38.963543	-120.457121
1852385	2020-12-31 23:57:50	3524574586339330	fraud_Heathcote, Yost and Kertzmann	shopping_net	29.56	Ashley	Cabrera	F	94225 Smith Springs Apt. 617	Vero Beach	FL	32960	27.6330	-80.4031	105638	Librarian, public	1986-05-07	9fc9f6f9be3182d519a61a119cf97199	1388534270	27.593881	-80.855092
1852386	2020-12-31 23:57:56	341546199006537	fraud_Schmidt-Larkin	home	12.68	Mark	Brown	M	8580 Moore Cove	Wales	AK	99783	64.7556	-165.6723	145	Administrator, education	1939-11-09	a8310343c189e4a5b6316050d2d6b014	1388534276	65.623593	-165.186033
1852387	2020-12-31 23:58:04	501802953619	fraud_Pouros, Walker and Spencer	kids_pets	13.02	Robert	Flores	M	3277 Fields Meadows Apt. 790	Greenview	CA	96037	41.5403	-122.9366	308	Call centre manager	1958-09-20	bd7071fd5c9510a5594ee196368ac80e	1388534284	41.973127	-123.553032
1852388	2020-12-31 23:58:34	3523843138706408	fraud_Prosacco, Kreiger and Kovacek	home	17.00	Grace	Williams	F	28812 Charles Mill Apt. 628	Plantersville	AL	36758	32.6176	-86.9475	1412	Drilling engineer	1970-11-20	6d04313bfe4b661b8ca2b6a499a320fe	1388534314	32.164145	-87.539669
1852389	2020-12-31 23:59:07	30560609640617	fraud_Reilly and Sons	health_fitness	43.77	Michael	Olson	M	558 Michael Estates	Luray	MO	63453	40.4931	-91.8912	519	Town planner	1966-02-13	9b1f753c79894c9f4b71f04581835ada	1388534347	39.946837	-91.333331
1852390	2020-12-31 23:59:09	3556613125071656	fraud_Hoppe-Parisian	kids_pets	111.84	Jose	Vasquez	M	572 Davis Mountains	Lake Jackson	TX	77566	29.0393	-95.4401	28739	Futures trader	1999-12-27	2090647dac2c89a1d86c514c427f5b91	1388534349	29.661049	-96.186633
1852391	2020-12-31 23:59:15	6011724471098086	fraud_Rau-Robel	kids_pets	86.88	Ann	Lawson	F	144 Evans Islands Apt. 683	Burbank	WA	99323	46.1966	-118.9017	3684	Musician	1981-11-29	6c5b7c8add471975aa0fec023b2e8408	1388534355	46.658340	-119.715054
1852392	2020-12-31 23:59:24	4079773899158	fraud_Breitenberg LLC	travel	7.99	Eric	Preston	M	7020 Doyle Stream Apt. 951	Mesa	ID	83643	44.6255	-116.4493	129	Cartographer	1965-12-15	14392d723bb7737606b2700ac791b7aa	1388534364	44.470525	-117.080888
1852393	2020-12-31 23:59:34	4170689372027579	fraud_Dare-Marvin	entertainment	38.13	Samuel	Frey	M	830 Myers Plaza Apt. 384	Edmond	OK	73034	35.6665	-97.4798	116001	Media buyer	1993-05-10	1765bb45b3aa3224b4cdcb6e7a96cee3	1388534374	36.210097	-97.036372

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category